/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package queenb.web.inteface;

import java.util.Date;
import java.util.List;
import queenb.net.entitybean.Q100;

/**
 *
 * @author Thanh Luan
 */
public interface Q100Inf {
    /*
     * ADMIN_TOOLS_INSERTTABQ100 param FN100 param QV101 param QV102 tao nguoi
     * su dung chuong trinh -- FN100: ID cua nhan vien -- FC4501: priority A --
     * FC4502: priority B -- FC4503: priority C -- FC5001: status open --
     * FC5002: status running -- FC5003: status close -- FC550: type (E, M, N)
     * -- QV101: user login -- QV102: PWD -- MD5 -- QD103: ngay bat dau co hieu
     * luc -- QD104: ngay ket thuc, het hieu luc -- QV105: email -- QV106:
     * Mobile -- QV107: tel -- QV108: fax -- QV109: phuong thuc lien lac, bao
     * tin -- QN110: -- QN111: -- QN112: -- QN113: -- BenutzerAnlegen(pvLOGIN,
     * pvKENNWORT);
     */

    public int updateQ100By(int pnFN100,
            int pnFC4501,
            int pnFC4502,
            int pnFC4503,
            int pnFC5001,
            int pnFC5002,
            int pnFC5003,
            String pvFC550,
            String pvQV101,
            String pvQV102,
            Date pdQD103,
            Date pdQD104,
            String pvQV105,
            String pvQV106,
            String pvQV107,
            String pvQV108,
            String pvQV109,
            int pnQN110,
            int pnQN111,
            int pnQN112,
            int pnQN113,
            String pvQV114,
            String pvQV115,
            String pvQV116,
            int pnFH000,
            String pvLOGIN);

    public int checkLoginExist(String pnLogin);
    public int updateQ100ById(int pnFN100, String pvQV101, String pvQV102N, String pvQV102A, String pvLOGIN);
    public int updateGoogleAccountById(int pnFN100,int pnFH000, String pvQV117, String pvQV118, String pvLOGIN);
    public int updateGoogleAccountReceiveById(int pnFN100,int pnFH000,String pvQV119, String pvQV120, String pvLOGIN);
    public int updateSignature(int pnFN100,int pnFH000,String pvQV121, String pvLOGIN);
    public List<Q100> getListTabQ100(int pn100, String pvLogin);

    public int updateQ100ByPass(String pvSchema,
            String pvTabName,
            String pvColName,
            String pnValue,
            String pvPrimakey,
            int pnCondition,
            String pvLogin);

    public List<Q100> getListCombQ100(int pnFH000,
            int pnFH200,
            int pnFN100,
            String pvLOGIN);
    public int getIdByUserLogin(String pnLogin);
}
